Interview Questions

1. You need to deploy the Standard Reports project. What should you do?

Options:

a. Deploy the project from SQL Server Data Tools (SSDT)

b. Use the Analysis Services Deployment utility to create an XMLA deployment script

c. Use the Analysis Services Deployment wizard to create an MDX deployment script

d. Use the Analysis Services Deployment wizard to create an XMLA deployment script

Reveal Answer

2. You are working with a SQL Server Reporting Services (SSRS) instance in native mode. An item role named Developer is present on the server. The Developer role cannot view and modify report caching parameters. You need to ensure that the Developer role can view and modify report caching parameters. Which task should you add to the Developer role?

Options:

a. View data sources

b. Manage individual subscriptions

c. Manage all subscriptions

d. Manage report history

Reveal Answer

3. How many ways can we deploy the project?

Options:

a. Deploy Report using SSDT

b. Deploy using Report Manager

c. Deploy Report using SSMS

d. None of these

Reveal Answer

4. Report Builder tool is used to generate ____________?

Options:

a. AD-HOC report

b. Linked reports

c. Snapshot reports

d. Cached reports

Reveal Answer

5. How to make some modification existing report?

Options:

a. By using Report Builder

b. By using Report Designer

c. All the above

d. None of these

Reveal Answer

6. Can we create multiple linked reports for a single report?

Options:

a. Yes

b. No

Reveal Answer

7. What are the different types of subscriptions?

Options:

a. Standard

b. Data Driven

c. All the above

d. None of these

Reveal Answer

8. Report Parts cannot be used by any user to create another report?

Options:

a. Yes

b. No

Reveal Answer

9. Can we specify the max number of report snapshots to be maintained in the report history?

Options:

a. Yes

b. No

Reveal Answer

10. Where can you specify System level Security?

Options:

a. General page

b. Security page

c. All the above

d. None of these

Reveal Answer

11. By Default SSRS authentication is based on _________?

Options:

a. Windows Authentication

b. Integrated security

c. None of these

Reveal Answer

Interview Questions and Answer

1. You need to deploy the Standard Reports project. What should you do?

3. How many ways can we deploy the project?

4. Report Builder tool is used to generate ____________?

5. How to make some modification existing report?

6. Can we create multiple linked reports for a single report?

7. What are the different types of subscriptions?

8. Report Parts cannot be used by any user to create another report?

9. Can we specify the max number of report snapshots to be maintained in the report history?

10. Where can you specify System level Security?

11. By Default SSRS authentication is based on _________?

Packages

Trending Certification Courses:

Microsoft Mock Exams:

Other links

About

Resources